1
2 <?php
3 include_once 'header.php';
4 ?>
5 <html>
6 <head>
7 <title>Gangs</title>
8 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
9
10 <!-- Optional theme -->
11 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
12
13 <!-- Latest compiled and minified JavaScript -->
14 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
15 </head>
16 <style>
17 table,th,td
18 {
19 font-family: monospace;
20 font-size: 150%;
21 padding: 0.25cm;
22 color: white;
23 }
24 body{
25 background-image: url("images/bllod.png");
26 background-repeat: no-repeat;
27 background-size:cover;
28 color: white;
29 }
30 button
31 {
32 display: block;
33 margin: 0 auto;
34 width: 10%;
35 height: 40px;
36 border: none;
37 background-color: #222;
38 font-family: arial;
39 font-size: 16px;
40 color: #fff;
41 cursor: pointer;
42 }
43 </style>
44
45 <head>
46 <h1 align="middle" style="font-size: 450%;"><u>Gangs Of Wasseypur 2</u></h1>
47 </head>
48
49
50 <body style="background-color: powderblue; font-family: monospace; margin: 0; padding: 0;">
51 <h1> </h1>
52 <p align=middle>
53 <video width="700" height="545" controls >
54 <source src="video/Gangs2.mp4" type="video/mp4">
55 </video>
56 <h1 align="middle" style="font-size: 300%;"><u><b>Trailer</b></u></h1>
57 </p>
58
59 <br><br><br><br>
60
61 <?php
62 $dbServername = "localhost";
63 $dbUsername = "root";
64 $dbPassword = "password";
65 $dbName = "test";
66
67 $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
68 $_SESSION['mov_name']="Gangs of Wasseypur 2";
69
70 $sql="SELECT description,genre,mov_lang,dir_name,stars from movie m,director d,rating r where d.dir_id=m.dir_id and r.mov_id=m.mov_id and mov_name='Gangs Of Wasseypur 2';";
71 mysqli_query($conn, $sql) or die('Error');
72 $result = mysqli_query($conn, $sql);
73 while($row=mysqli_fetch_array($result))
74 {
75 echo '<table style= "marign-right:20%; margin-left:20%;" >
76
77 <tr>
78 <td><u><b> Description</b></u></td>
79 <td>'.$row['description'].'</td>
80 </tr>
81 <tr>
82 <td><u> <b>Genre</b></u></td>
83 <td>'.$row['genre'].'</td>
84 </tr>
85 <tr>
86 <td><u><b> Language </b></u></td>
87 <td>'.$row['mov_lang'].'</td>
88 </tr>
89 <tr>
90 <td><u><b> Director</b> </u></td>
91 <td>'.$row['dir_name'].'</td>
92 </tr>
93 <tr>
94 <td><u><b>Rating</b> </u></td>
95 <td>'.$row['stars'].'</td>
96 </tr>
97 </table><br><br><br>';
98 }
99 ?>
100
101 <h1 align="middle" style="font-size: 300%;"><br><u><b>Cast</b></u></h1>
102
103 <?php
104 $sql1="SELECT actor_name,role from actor a,movie m,movie_cast mc where a.actor_id=mc.actor_id and mc.mov_id=m.mov_id and m.mov_name='Gangs Of Wasseypur 2';";
105 mysqli_query($conn, $sql) or die('Error');
106 $result1 = mysqli_query($conn, $sql1);
107 echo '<br><br><br><table style="margin-left: auto; margin-right: auto;">
108 <tr align="middle">
109 <td><u><b>Actor</b></u></td>
110 <td><u><b>Role</b></u></td>
111 </tr>';
112 while($row=mysqli_fetch_array($result1))
113 {
114 echo '<tr>
115 <td>'.$row['actor_name'].'</td>
116 <td align="middle">'.$row['role'].'</td>
117 </tr>';
118 }
119
120 echo '</table><br><br><br>';
121
122 $_SESSION['mov_name']="Gangs Of Wasseypur 2";
123
124 ?>
125
126 <center><a href="nowshowing.php" class="btn btn-default btn-lg" style="font-size:15px padding-top:0.25%; font-family: comic sans ms; color: black" role="button"><b>Book now</b></a></center><br>
127
128 </body>
129 </html>
130
131 <?php
132 include_once 'footer.php';
133 ?>